Project Database Utility

The Project Database Utility can be used to create a project database, upgrade a project database, and update the parts database schema.

Create Project Database Tab

Setting	Description
Database Script	Select the script file you wish to execute. To create a new SQL database, select SqlServerProject.sql. Script files are installed by the software within the ...\Program Files\Bentley\OpenUtilities Substation CONNECT Edition\Substation folder.
Server Name	Select the name of your server. If your server is not listed in the pull-down you can manually enter the server name. Note: If you are not sure what your server is called, you can try connecting to your SQL Server using SQL Server Management Studio. The server name shown in this tool is what you must enter in this field.
Windows Authentication	Select this option if you would like to log into your database server using your Windows login.
Server Authentication	Select this option if you would like to log into your database server using a login defined by your database server.
SA Password	Enter your SQL Server's system administrator password. Note: This password is only required if you are using Server Authentication.
Database Name	Enter the name of the database that you would like to create. Note: By default OpenUtilities Substation uses OpenUtilities Substation as the database name.
Datafile Path	Select the Detect button to automatically locate your database server's datafile path. If it can not detect your datafile path, use the Browse button to locate it manually.
Datafile Size	Specify how much disk space you want to initially reserve for the database. Note: This does not limit your database to this size because the database script permits dynamic growth as needed.
Username	Enter your SQL Server user login name. Note: This login is only required if you are using Server Authentication.
Password	Enter your SQL Server user password that corresponds to the Username you specified above. Note: This password is only required if you are using Server Authentication.
Confirm Password	Re-enter your SQL Server user password to ensure you typed it correctly. Note: This password is only required if you are using Server Authentication.
Test Connection	Select this button to verify that the Project Database Utility can properly connect to your server using the login information that you have provided. If there is a problem, it will display a message in red text above this button. If it is successful, a Test Successful message will display. The Execute Script button should then be enabled.
Execute Script	Select this button to run the database script file you selected and create your project database.

Upgrade Project Database Tab

You can use this tab to upgrade a legacy project database to the current version used by the software.

Setting	Description
Setup Configuration	Select the setup configuration that connects to the project database you want to upgrade.
Database Type	Select the type of database server you are using. You can choose between SQL Server or Oracle.
Server name	Enter the name of your database server. Note: If you are not sure what your server is called, you can try connecting to your SQL Server using SQL Server Management Studio. The server name shown in this tool is what you must enter in this field.
Database	Enter the name of the database that you would like to create. Note: By default OpenUtilities Substation uses OpenUtilities Substation as the database name.
Connect using	Select the method you wish to use to connect to your database. You can choose between the following choices: Windows Authentication - Select this option if you would like to log into your database server using your Windows login. Server Authentication - Select this option if you would like to log into your database server using a login defined by your database server.
Login Name	Enter your SQL Server user login name. Note: This login is only required if you are using Server Authentication.
Password	Enter your SQL Server user password that corresponds to the Login Name you specified above. Note: This password is only required if you are using Server Authentication.
Upgrade Database	Press this button to upgrade your existing database to the current version. Note: To be able to upgrade the database you must have the appropriate permissions assigned for the database. See section below.

Database Permissions

In order to upgrade the database you must have permission to do so. This Server Roles are assigned by the project administrator for the SQL database:

If the "sysadmin" role is not assigned for a user when attempting to upgrade the database, the following message displays:

Contact the project administrator if this message is displayed.

Update Parts Database Schema Tab

If the current version of the software requires a different parts database schema than your legacy parts database uses, you can use this tab to update your existing parts database to the new schema.

Setting	Description
PartsDatabaseName	Displays the names of any databases called in your setup configurations that require a schema update. If nothing is listed, your current databases are already using the correct schema.
Updated	Indicate whether your existing parts database is updated to the new schema. The status of this field is updated once you press Update.
Details	Displays a message if the Project Database Utility is unable to update your parts database.
Update	Updates your existing parts database(s).